Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 29500 |
| Missing cells | 72214 |
| Missing cells (%) | 12.2% |
| Duplicate rows | 107 |
| Duplicate rows (%) | 0.4% |
| Total size in memory | 4.5 MiB |
| Average record size in memory | 160.0 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 14 |
| Boolean | 2 |
| Dataset has 107 (0.4%) duplicate rows | Duplicates |
weekid has a high cardinality: 3262 distinct values | High cardinality |
song has a high cardinality: 24359 distinct values | High cardinality |
performer has a high cardinality: 10059 distinct values | High cardinality |
week_position is highly correlated with peak_position | High correlation |
weeks_on_chart is highly correlated with peak_position | High correlation |
peak_position is highly correlated with week_position and 1 other fields | High correlation |
energy is highly correlated with loudness and 1 other fields | High correlation |
loudness is highly correlated with energy | High correlation |
acousticness is highly correlated with energy | High correlation |
weeks_on_chart is highly correlated with peak_position | High correlation |
peak_position is highly correlated with weeks_on_chart | High correlation |
energy is highly correlated with loudness and 1 other fields | High correlation |
loudness is highly correlated with energy | High correlation |
acousticness is highly correlated with energy | High correlation |
weeks_on_chart is highly correlated with peak_position | High correlation |
peak_position is highly correlated with weeks_on_chart | High correlation |
weeks_on_chart is highly correlated with peak_position | High correlation |
peak_position is highly correlated with weeks_on_chart and 1 other fields | High correlation |
acousticness is highly correlated with energy | High correlation |
energy is highly correlated with acousticness and 1 other fields | High correlation |
speechiness is highly correlated with spotify_track_explicit | High correlation |
time_signature is highly correlated with tempo and 1 other fields | High correlation |
spotify_track_explicit is highly correlated with speechiness | High correlation |
tempo is highly correlated with time_signature and 1 other fields | High correlation |
week_position is highly correlated with peak_position | High correlation |
loudness is highly correlated with energy | High correlation |
danceability is highly correlated with time_signature and 1 other fields | High correlation |
spotify_track_duration_ms has 5105 (17.3%) missing values | Missing |
spotify_track_explicit has 5105 (17.3%) missing values | Missing |
danceability has 5167 (17.5%) missing values | Missing |
energy has 5167 (17.5%) missing values | Missing |
key has 5167 (17.5%) missing values | Missing |
loudness has 5167 (17.5%) missing values | Missing |
mode has 5167 (17.5%) missing values | Missing |
speechiness has 5167 (17.5%) missing values | Missing |
acousticness has 5167 (17.5%) missing values | Missing |
instrumentalness has 5167 (17.5%) missing values | Missing |
liveness has 5167 (17.5%) missing values | Missing |
valence has 5167 (17.5%) missing values | Missing |
tempo has 5167 (17.5%) missing values | Missing |
time_signature has 5167 (17.5%) missing values | Missing |
song is uniformly distributed | Uniform |
key has 3035 (10.3%) zeros | Zeros |
instrumentalness has 10079 (34.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-08-15 21:12:17.214179 |
|---|---|
| Analysis finished | 2021-08-15 21:12:48.032212 |
| Duration | 30.82 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 3262 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 230.6 KiB |
| 2021-05-29 | 99 |
|---|---|
| 1998-11-28 | 54 |
| 2021-01-02 | 38 |
| 2019-08-24 | 29 |
| 2021-01-09 | 27 |
| Other values (3257) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 295000 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2009-12-26 |
|---|---|
| 2nd row | 2014-01-04 |
| 3rd row | 2017-07-29 |
| 4th row | 2018-12-22 |
| 5th row | 2019-06-01 |
Common Values
| Value | Count | Frequency (%) |
| 2021-05-29 | 99 | 0.3% |
| 1998-11-28 | 54 | 0.2% |
| 2021-01-02 | 38 | 0.1% |
| 2019-08-24 | 29 | 0.1% |
| 2021-01-09 | 27 | 0.1% |
| 2020-03-07 | 24 | 0.1% |
| 1968-08-24 | 23 | 0.1% |
| 2020-03-14 | 23 | 0.1% |
| 1966-03-12 | 23 | 0.1% |
| 2021-05-22 | 23 | 0.1% |
| Other values (3252) | 29137 |
Length
| Value | Count | Frequency (%) |
| 2021-05-29 | 99 | 0.3% |
| 1998-11-28 | 54 | 0.2% |
| 2021-01-02 | 38 | 0.1% |
| 2019-08-24 | 29 | 0.1% |
| 2021-01-09 | 27 | 0.1% |
| 2020-03-07 | 24 | 0.1% |
| 1968-08-24 | 23 | 0.1% |
| 2020-03-14 | 23 | 0.1% |
| 1966-03-12 | 23 | 0.1% |
| 2021-05-22 | 23 | 0.1% |
| Other values (3252) | 29137 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 59000 | |
| 1 | 53501 | |
| 0 | 52227 | |
| 9 | 32728 | |
| 2 | 30028 | |
| 6 | 14937 | 5.1% |
| 7 | 13289 | 4.5% |
| 8 | 12638 | 4.3% |
| 3 | 9582 | 3.2% |
| 5 | 9098 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 236000 | |
| Dash Punctuation | 59000 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 53501 | |
| 0 | 52227 | |
| 9 | 32728 | |
| 2 | 30028 | |
| 6 | 14937 | 6.3% |
| 7 | 13289 | 5.6% |
| 8 | 12638 | 5.4% |
| 3 | 9582 | 4.1% |
| 5 | 9098 | 3.9% |
| 4 | 7972 | 3.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 59000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 295000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 59000 | |
| 1 | 53501 | |
| 0 | 52227 | |
| 9 | 32728 | |
| 2 | 30028 | |
| 6 | 14937 | 5.1% |
| 7 | 13289 | 4.5% |
| 8 | 12638 | 4.3% |
| 3 | 9582 | 3.2% |
| 5 | 9098 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 295000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 59000 | |
| 1 | 53501 | |
| 0 | 52227 | |
| 9 | 32728 | |
| 2 | 30028 | |
| 6 | 14937 | 5.1% |
| 7 | 13289 | 4.5% |
| 8 | 12638 | 4.3% |
| 3 | 9582 | 3.2% |
| 5 | 9098 | 3.1% |
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.5679322 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 59 |
| median | 85 |
| Q3 | 95 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 21.71969083 |
|---|---|
| Coefficient of variation (CV) | 0.2836656314 |
| Kurtosis | -0.7435583955 |
| Mean | 76.5679322 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.7243040582 |
| Sum | 2258754 |
| Variance | 471.7449698 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 1715 | 5.8% |
| 99 | 1538 | 5.2% |
| 98 | 1418 | 4.8% |
| 97 | 1387 | 4.7% |
| 96 | 1187 | 4.0% |
| 94 | 1081 | 3.7% |
| 95 | 1054 | 3.6% |
| 93 | 938 | 3.2% |
| 92 | 851 | 2.9% |
| 91 | 826 | 2.8% |
| Other values (90) | 17505 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 6 | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1715 | |
| 99 | 1538 | |
| 98 | 1418 | |
| 97 | 1387 | |
| 96 | 1187 | |
| 95 | 1054 | |
| 94 | 1081 | |
| 93 | 938 | |
| 92 | 851 | |
| 91 | 826 |
| Distinct | 24359 |
|---|---|
| Distinct (%) | 82.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 230.6 KiB |
| Hold On | 17 |
|---|---|
| Forever | 14 |
| Stay | 14 |
| You | 14 |
| Angel | 14 |
| Other values (24354) |
Length
| Max length | 75 |
|---|---|
| Median length | 15 |
| Mean length | 16.55481356 |
| Min length | 1 |
Characters and Unicode
| Total characters | 488367 |
|---|---|
| Distinct characters | 96 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 21233 ? |
|---|---|
| Unique (%) | 72.0% |
Sample
| 1st row | My Life Would Suck Without You |
|---|---|
| 2nd row | I Have Nothing |
| 3rd row | Family Feud |
| 4th row | I Don't Let Go |
| 5th row | I Think |
Common Values
| Value | Count | Frequency (%) |
| Hold On | 17 | 0.1% |
| Forever | 14 | < 0.1% |
| Stay | 14 | < 0.1% |
| You | 14 | < 0.1% |
| Angel | 14 | < 0.1% |
| Happy | 13 | < 0.1% |
| Without You | 12 | < 0.1% |
| Smile | 12 | < 0.1% |
| Runaway | 12 | < 0.1% |
| I Need You | 11 | < 0.1% |
| Other values (24349) | 29367 |
Length
| Value | Count | Frequency (%) |
| the | 3867 | 3.9% |
| you | 3088 | 3.1% |
| i | 2354 | 2.4% |
| love | 2242 | 2.3% |
| me | 1963 | 2.0% |
| a | 1766 | 1.8% |
| to | 1617 | 1.6% |
| my | 1387 | 1.4% |
| of | 1373 | 1.4% |
| in | 1282 | 1.3% |
| Other values (9564) | 77824 |
Most occurring characters
| Value | Count | Frequency (%) |
| 69263 | 14.2% | |
| e | 45868 | 9.4% |
| o | 33707 | 6.9% |
| n | 24944 | 5.1% |
| a | 23724 | 4.9% |
| t | 21130 | 4.3% |
| i | 20280 | 4.2% |
| r | 19551 | 4.0% |
| l | 14592 | 3.0% |
| h | 14083 | 2.9% |
| Other values (86) | 201225 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 304919 | |
| Uppercase Letter | 99278 | 20.3% |
| Space Separator | 69263 | 14.2% |
| Other Punctuation | 8860 | 1.8% |
| Open Punctuation | 2094 | 0.4% |
| Close Punctuation | 2092 | 0.4% |
| Decimal Number | 1153 | 0.2% |
| Dash Punctuation | 673 | 0.1% |
| Currency Symbol | 18 | < 0.1% |
| Math Symbol | 15 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 45868 | |
| o | 33707 | |
| n | 24944 | 8.2% |
| a | 23724 | 7.8% |
| t | 21130 | 6.9% |
| i | 20280 | 6.7% |
| r | 19551 | 6.4% |
| l | 14592 | 4.8% |
| h | 14083 | 4.6% |
| s | 13367 | 4.4% |
| Other values (23) | 73673 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 10953 | 11.0% |
| I | 7541 | 7.6% |
| M | 7223 | 7.3% |
| S | 7092 | 7.1% |
| L | 6885 | 6.9% |
| A | 6264 | 6.3% |
| W | 5702 | 5.7% |
| B | 5687 | 5.7% |
| Y | 4814 | 4.8% |
| O | 4522 | 4.6% |
| Other values (17) | 32595 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 5491 | |
| , | 913 | 10.3% |
| . | 862 | 9.7% |
| " | 558 | 6.3% |
| / | 275 | 3.1% |
| ! | 211 | 2.4% |
| ? | 206 | 2.3% |
| & | 170 | 1.9% |
| * | 128 | 1.4% |
| # | 19 | 0.2% |
| Other values (5) | 27 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 288 | |
| 2 | 187 | |
| 0 | 152 | |
| 9 | 109 | 9.5% |
| 4 | 105 | 9.1% |
| 3 | 79 | 6.9% |
| 5 | 74 | 6.4% |
| 7 | 58 | 5.0% |
| 6 | 56 | 4.9% |
| 8 | 45 | 3.9% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 12 | |
| = | 2 | 13.3% |
| > | 1 | 6.7% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2087 | |
| [ | 7 | 0.3% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2085 | |
| ] | 7 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 69263 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 673 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 18 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 404197 | |
| Common | 84170 | 17.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 45868 | 11.3% |
| o | 33707 | 8.3% |
| n | 24944 | 6.2% |
| a | 23724 | 5.9% |
| t | 21130 | 5.2% |
| i | 20280 | 5.0% |
| r | 19551 | 4.8% |
| l | 14592 | 3.6% |
| h | 14083 | 3.5% |
| s | 13367 | 3.3% |
| Other values (50) | 172951 |
Common
| Value | Count | Frequency (%) |
| 69263 | ||
| ' | 5491 | 6.5% |
| ( | 2087 | 2.5% |
| ) | 2085 | 2.5% |
| , | 913 | 1.1% |
| . | 862 | 1.0% |
| - | 673 | 0.8% |
| " | 558 | 0.7% |
| 1 | 288 | 0.3% |
| / | 275 | 0.3% |
| Other values (26) | 1675 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 488350 | |
| Latin 1 Sup | 17 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 69263 | 14.2% | |
| e | 45868 | 9.4% |
| o | 33707 | 6.9% |
| n | 24944 | 5.1% |
| a | 23724 | 4.9% |
| t | 21130 | 4.3% |
| i | 20280 | 4.2% |
| r | 19551 | 4.0% |
| l | 14592 | 3.0% |
| h | 14083 | 2.9% |
| Other values (77) | 201208 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| é | 5 | |
| á | 3 | |
| ó | 2 | 11.8% |
| ñ | 2 | 11.8% |
| ¿ | 1 | 5.9% |
| ò | 1 | 5.9% |
| à | 1 | 5.9% |
| ö | 1 | 5.9% |
| Ó | 1 | 5.9% |
| Distinct | 10059 |
|---|---|
| Distinct (%) | 34.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 230.6 KiB |
| Glee Cast | 183 |
|---|---|
| Taylor Swift | 119 |
| Drake | 99 |
| The Beatles | 65 |
| Aretha Franklin | 64 |
| Other values (10054) |
Length
| Max length | 113 |
|---|---|
| Median length | 12 |
| Mean length | 15.06430508 |
| Min length | 1 |
Characters and Unicode
| Total characters | 444397 |
|---|---|
| Distinct characters | 81 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6453 ? |
|---|---|
| Unique (%) | 21.9% |
Sample
| 1st row | Glee Cast |
|---|---|
| 2nd row | Tessanne Chin |
| 3rd row | JAY-Z Featuring Beyonce |
| 4th row | XXXTENTACION |
| 5th row | Tyler, The Creator |
Common Values
| Value | Count | Frequency (%) |
| Glee Cast | 183 | 0.6% |
| Taylor Swift | 119 | 0.4% |
| Drake | 99 | 0.3% |
| The Beatles | 65 | 0.2% |
| Aretha Franklin | 64 | 0.2% |
| Elton John | 58 | 0.2% |
| The Rolling Stones | 57 | 0.2% |
| The Beach Boys | 54 | 0.2% |
| Stevie Wonder | 54 | 0.2% |
| Madonna | 53 | 0.2% |
| Other values (10049) | 28694 |
Length
| Value | Count | Frequency (%) |
| the | 4965 | 6.5% |
| featuring | 2540 | 3.3% |
| 2407 | 3.2% | |
| and | 929 | 1.2% |
| lil | 507 | 0.7% |
| john | 369 | 0.5% |
| bobby | 361 | 0.5% |
| brown | 336 | 0.4% |
| band | 328 | 0.4% |
| with | 305 | 0.4% |
| Other values (8042) | 62944 |
Most occurring characters
| Value | Count | Frequency (%) |
| 46491 | 10.5% | |
| e | 42641 | 9.6% |
| a | 32103 | 7.2% |
| n | 28531 | 6.4% |
| i | 26042 | 5.9% |
| r | 25164 | 5.7% |
| o | 22022 | 5.0% |
| l | 17723 | 4.0% |
| t | 17594 | 4.0% |
| s | 16994 | 3.8% |
| Other values (71) | 169092 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 313295 | |
| Uppercase Letter | 77135 | 17.4% |
| Space Separator | 46491 | 10.5% |
| Other Punctuation | 5351 | 1.2% |
| Decimal Number | 1122 | 0.3% |
| Dash Punctuation | 644 | 0.1% |
| Open Punctuation | 109 | < 0.1% |
| Close Punctuation | 109 | < 0.1% |
| Currency Symbol | 89 | < 0.1% |
| Math Symbol | 51 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 8442 | 10.9% |
| B | 6761 | 8.8% |
| S | 5789 | 7.5% |
| C | 5452 | 7.1% |
| F | 4928 | 6.4% |
| M | 4769 | 6.2% |
| J | 4633 | 6.0% |
| D | 4290 | 5.6% |
| A | 3683 | 4.8% |
| R | 3568 | 4.6% |
| Other values (16) | 24820 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 42641 | |
| a | 32103 | |
| n | 28531 | |
| i | 26042 | 8.3% |
| r | 25164 | 8.0% |
| o | 22022 | 7.0% |
| l | 17723 | 5.7% |
| t | 17594 | 5.6% |
| s | 16994 | 5.4% |
| h | 13745 | 4.4% |
| Other values (16) | 70736 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 2360 | |
| . | 1603 | |
| , | 531 | 9.9% |
| ' | 476 | 8.9% |
| " | 185 | 3.5% |
| ! | 96 | 1.8% |
| / | 75 | 1.4% |
| ? | 11 | 0.2% |
| * | 10 | 0.2% |
| : | 4 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 243 | |
| 0 | 181 | |
| 5 | 173 | |
| 1 | 162 | |
| 4 | 102 | |
| 3 | 79 | 7.0% |
| 6 | 67 | 6.0% |
| 9 | 56 | 5.0% |
| 7 | 31 | 2.8% |
| 8 | 28 | 2.5% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 106 | |
| [ | 3 | 2.8% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 106 | |
| ] | 3 | 2.8% |
Space Separator
| Value | Count | Frequency (%) |
| 46491 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 644 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 89 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 51 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 390430 | |
| Common | 53967 | 12.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 42641 | 10.9% |
| a | 32103 | 8.2% |
| n | 28531 | 7.3% |
| i | 26042 | 6.7% |
| r | 25164 | 6.4% |
| o | 22022 | 5.6% |
| l | 17723 | 4.5% |
| t | 17594 | 4.5% |
| s | 16994 | 4.4% |
| h | 13745 | 3.5% |
| Other values (42) | 147871 |
Common
| Value | Count | Frequency (%) |
| 46491 | ||
| & | 2360 | 4.4% |
| . | 1603 | 3.0% |
| - | 644 | 1.2% |
| , | 531 | 1.0% |
| ' | 476 | 0.9% |
| 2 | 243 | 0.5% |
| " | 185 | 0.3% |
| 0 | 181 | 0.3% |
| 5 | 173 | 0.3% |
| Other values (19) | 1080 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 444397 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 46491 | 10.5% | |
| e | 42641 | 9.6% |
| a | 32103 | 7.2% |
| n | 28531 | 6.4% |
| i | 26042 | 5.9% |
| r | 25164 | 5.7% |
| o | 22022 | 5.0% |
| l | 17723 | 4.0% |
| t | 17594 | 4.0% |
| s | 16994 | 3.8% |
| Other values (71) | 169092 |
weeks_on_chart
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 69 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.20318644 |
| Minimum | 1 |
|---|---|
| Maximum | 87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 10 |
| Q3 | 16 |
| 95-th percentile | 25 |
| Maximum | 87 |
| Range | 86 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 8.337059611 |
|---|---|
| Coefficient of variation (CV) | 0.7441686037 |
| Kurtosis | 3.61344583 |
| Mean | 11.20318644 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.340103597 |
| Sum | 330494 |
| Variance | 69.50656295 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2520 | 8.5% |
| 20 | 2354 | 8.0% |
| 2 | 1670 | 5.7% |
| 8 | 1594 | 5.4% |
| 7 | 1580 | 5.4% |
| 6 | 1575 | 5.3% |
| 5 | 1439 | 4.9% |
| 9 | 1413 | 4.8% |
| 3 | 1413 | 4.8% |
| 4 | 1394 | 4.7% |
| Other values (59) | 12548 |
| Value | Count | Frequency (%) |
| 1 | 2520 | |
| 2 | 1670 | |
| 3 | 1413 | |
| 4 | 1394 | |
| 5 | 1439 | |
| 6 | 1575 | |
| 7 | 1580 | |
| 8 | 1594 | |
| 9 | 1413 | |
| 10 | 1279 |
| Value | Count | Frequency (%) |
| 87 | 1 | < 0.1% |
| 79 | 1 | < 0.1% |
| 76 | 2 | |
| 69 | 1 | < 0.1% |
| 68 | 2 | |
| 65 | 2 | |
| 64 | 1 | < 0.1% |
| 62 | 3 | |
| 61 | 2 | |
| 60 | 2 |
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.40844068 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 19 |
| median | 47 |
| Q3 | 75 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 56 |
Descriptive statistics
| Standard deviation | 30.93113972 |
|---|---|
| Coefficient of variation (CV) | 0.6524395082 |
| Kurtosis | -1.302364969 |
| Mean | 47.40844068 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 0.06412696724 |
| Sum | 1398549 |
| Variance | 956.7354045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1107 | 3.8% |
| 3 | 504 | 1.7% |
| 2 | 499 | 1.7% |
| 4 | 445 | 1.5% |
| 5 | 426 | 1.4% |
| 7 | 408 | 1.4% |
| 6 | 403 | 1.4% |
| 8 | 389 | 1.3% |
| 91 | 384 | 1.3% |
| 10 | 381 | 1.3% |
| Other values (90) | 24554 |
| Value | Count | Frequency (%) |
| 1 | 1107 | |
| 2 | 499 | |
| 3 | 504 | |
| 4 | 445 | |
| 5 | 426 | 1.4% |
| 6 | 403 | 1.4% |
| 7 | 408 | 1.4% |
| 8 | 389 | 1.3% |
| 9 | 375 | 1.3% |
| 10 | 381 | 1.3% |
| Value | Count | Frequency (%) |
| 100 | 247 | |
| 99 | 282 | |
| 98 | 302 | |
| 97 | 329 | |
| 96 | 304 | |
| 95 | 302 | |
| 94 | 333 | |
| 93 | 314 | |
| 92 | 353 | |
| 91 | 384 |
| Distinct | 13983 |
|---|---|
| Distinct (%) | 57.3% |
| Missing | 5105 |
| Missing (%) | 17.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 220681.1945 |
| Minimum | 29688 |
|---|---|
| Maximum | 3079157 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 29688 |
|---|---|
| 5-th percentile | 135658.2 |
| Q1 | 175053 |
| median | 214850 |
| Q3 | 253253 |
| 95-th percentile | 327746.3 |
| Maximum | 3079157 |
| Range | 3049469 |
| Interquartile range (IQR) | 78200 |
Descriptive statistics
| Standard deviation | 67745.14511 |
|---|---|
| Coefficient of variation (CV) | 0.3069819576 |
| Kurtosis | 146.2738291 |
| Mean | 220681.1945 |
| Median Absolute Deviation (MAD) | 39150 |
| Skewness | 4.973578707 |
| Sum | 5383517741 |
| Variance | 4589404686 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 205733 | 10 | < 0.1% |
| 160000 | 10 | < 0.1% |
| 196000 | 9 | < 0.1% |
| 280000 | 9 | < 0.1% |
| 251333 | 9 | < 0.1% |
| 161533 | 9 | < 0.1% |
| 231400 | 9 | < 0.1% |
| 227266 | 9 | < 0.1% |
| 229466 | 9 | < 0.1% |
| 159666 | 8 | < 0.1% |
| Other values (13973) | 24304 | |
| (Missing) | 5105 | 17.3% |
| Value | Count | Frequency (%) |
| 29688 | 1 | |
| 37013 | 1 | |
| 46253 | 1 | |
| 48000 | 1 | |
| 49292 | 1 | |
| 61306 | 1 | |
| 67749 | 1 | |
| 69000 | 1 | |
| 70556 | 1 | |
| 71306 | 1 |
| Value | Count | Frequency (%) |
| 3079157 | 1 | |
| 1561133 | 1 | |
| 1367093 | 1 | |
| 1124153 | 1 | |
| 1008533 | 1 | |
| 992160 | 1 | |
| 941360 | 1 | |
| 901000 | 1 | |
| 869333 | 1 | |
| 834866 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5105 |
| Missing (%) | 17.3% |
| Memory size | 230.6 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 21447 | |
| True | 2948 | 10.0% |
| (Missing) | 5105 | 17.3% |
| Distinct | 837 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5999513418 |
| Minimum | 0 |
|---|---|
| Maximum | 0.988 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.329 |
| Q1 | 0.499 |
| median | 0.608 |
| Q3 | 0.708 |
| 95-th percentile | 0.845 |
| Maximum | 0.988 |
| Range | 0.988 |
| Interquartile range (IQR) | 0.209 |
Descriptive statistics
| Standard deviation | 0.1531327566 |
|---|---|
| Coefficient of variation (CV) | 0.2552419604 |
| Kurtosis | -0.2349437672 |
| Mean | 0.5999513418 |
| Median Absolute Deviation (MAD) | 0.104 |
| Skewness | -0.2366541587 |
| Sum | 14598.616 |
| Variance | 0.02344964115 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.637 | 86 | 0.3% |
| 0.674 | 82 | 0.3% |
| 0.628 | 82 | 0.3% |
| 0.652 | 81 | 0.3% |
| 0.66 | 80 | 0.3% |
| 0.61 | 79 | 0.3% |
| 0.602 | 79 | 0.3% |
| 0.551 | 77 | 0.3% |
| 0.589 | 76 | 0.3% |
| 0.623 | 74 | 0.3% |
| Other values (827) | 23537 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.103 | 1 | |
| 0.105 | 1 | |
| 0.107 | 1 | |
| 0.11 | 1 | |
| 0.111 | 1 | |
| 0.113 | 2 | |
| 0.12 | 1 | |
| 0.123 | 1 | |
| 0.126 | 1 |
| Value | Count | Frequency (%) |
| 0.988 | 1 | < 0.1% |
| 0.986 | 1 | < 0.1% |
| 0.981 | 1 | < 0.1% |
| 0.98 | 2 | < 0.1% |
| 0.978 | 2 | < 0.1% |
| 0.974 | 6 | |
| 0.973 | 2 | < 0.1% |
| 0.972 | 1 | < 0.1% |
| 0.971 | 1 | < 0.1% |
| 0.968 | 1 | < 0.1% |
| Distinct | 985 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6181075774 |
| Minimum | 0.000581 |
|---|---|
| Maximum | 0.997 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0.000581 |
|---|---|
| 5-th percentile | 0.2686 |
| Q1 | 0.476 |
| median | 0.634 |
| Q3 | 0.778 |
| 95-th percentile | 0.9134 |
| Maximum | 0.997 |
| Range | 0.996419 |
| Interquartile range (IQR) | 0.302 |
Descriptive statistics
| Standard deviation | 0.1990736472 |
|---|---|
| Coefficient of variation (CV) | 0.3220695789 |
| Kurtosis | -0.5962893818 |
| Mean | 0.6181075774 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | -0.3293440475 |
| Sum | 15040.41168 |
| Variance | 0.039630317 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.73 | 62 | 0.2% |
| 0.671 | 58 | 0.2% |
| 0.727 | 58 | 0.2% |
| 0.72 | 58 | 0.2% |
| 0.743 | 57 | 0.2% |
| 0.804 | 57 | 0.2% |
| 0.641 | 56 | 0.2% |
| 0.61 | 56 | 0.2% |
| 0.623 | 54 | 0.2% |
| 0.703 | 54 | 0.2% |
| Other values (975) | 23763 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0.000581 | 1 | |
| 0.0181 | 1 | |
| 0.0201 | 1 | |
| 0.0204 | 1 | |
| 0.021 | 1 | |
| 0.022 | 1 | |
| 0.0222 | 1 | |
| 0.0223 | 1 | |
| 0.0227 | 1 | |
| 0.0246 | 1 |
| Value | Count | Frequency (%) |
| 0.997 | 1 | < 0.1% |
| 0.996 | 2 | < 0.1% |
| 0.995 | 4 | |
| 0.994 | 5 | |
| 0.993 | 6 | |
| 0.992 | 1 | < 0.1% |
| 0.991 | 7 | |
| 0.99 | 1 | < 0.1% |
| 0.989 | 5 | |
| 0.988 | 6 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.231578515 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 3035 |
| Zeros (%) | 10.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 11 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.560265626 |
|---|---|
| Coefficient of variation (CV) | 0.6805337273 |
| Kurtosis | -1.29054339 |
| Mean | 5.231578515 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.00151409637 |
| Sum | 127300 |
| Variance | 12.67549133 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3035 | |
| 7 | 2851 | |
| 2 | 2502 | |
| 9 | 2448 | |
| 5 | 2183 | |
| 1 | 2181 | |
| 4 | 1885 | 6.4% |
| 10 | 1773 | 6.0% |
| 11 | 1702 | 5.8% |
| 8 | 1519 | 5.1% |
| Other values (2) | 2254 | |
| (Missing) | 5167 |
| Value | Count | Frequency (%) |
| 0 | 3035 | |
| 1 | 2181 | |
| 2 | 2502 | |
| 3 | 819 | 2.8% |
| 4 | 1885 | |
| 5 | 2183 | |
| 6 | 1435 | |
| 7 | 2851 | |
| 8 | 1519 | |
| 9 | 2448 |
| Value | Count | Frequency (%) |
| 11 | 1702 | |
| 10 | 1773 | |
| 9 | 2448 | |
| 8 | 1519 | |
| 7 | 2851 | |
| 6 | 1435 | |
| 5 | 2183 | |
| 4 | 1885 | |
| 3 | 819 | 2.8% |
| 2 | 2502 |
| Distinct | 11165 |
|---|---|
| Distinct (%) | 45.9% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -8.664383759 |
| Minimum | -28.03 |
|---|---|
| Maximum | 2.291 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 24331 |
| Negative (%) | 82.5% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | -28.03 |
|---|---|
| 5-th percentile | -15.0694 |
| Q1 | -11.034 |
| median | -8.205 |
| Q3 | -5.856 |
| 95-th percentile | -3.703 |
| Maximum | 2.291 |
| Range | 30.321 |
| Interquartile range (IQR) | 5.178 |
Descriptive statistics
| Standard deviation | 3.6010244 |
|---|---|
| Coefficient of variation (CV) | -0.4156122928 |
| Kurtosis | 0.3478938965 |
| Mean | -8.664383759 |
| Median Absolute Deviation (MAD) | 2.538 |
| Skewness | -0.6489054219 |
| Sum | -210830.45 |
| Variance | 12.96737673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5.318 | 10 | < 0.1% |
| -9.088 | 10 | < 0.1% |
| -7.076 | 10 | < 0.1% |
| -5.18 | 10 | < 0.1% |
| -5.987 | 9 | < 0.1% |
| -8.749 | 9 | < 0.1% |
| -5.076 | 9 | < 0.1% |
| -5.79 | 9 | < 0.1% |
| -6.836 | 9 | < 0.1% |
| -9.903 | 8 | < 0.1% |
| Other values (11155) | 24240 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| -28.03 | 1 | |
| -27.861 | 1 | |
| -27.119 | 1 | |
| -27.01 | 1 | |
| -26.826 | 1 | |
| -26.549 | 1 | |
| -26.149 | 1 | |
| -25.487 | 1 | |
| -25.473 | 1 | |
| -25.035 | 1 |
| Value | Count | Frequency (%) |
| 2.291 | 1 | |
| 0.175 | 1 | |
| -0.463 | 1 | |
| -0.507 | 1 | |
| -0.517 | 1 | |
| -0.698 | 1 | |
| -0.81 | 1 | |
| -0.883 | 1 | |
| -0.884 | 1 | |
| -0.945 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Memory size | 230.6 KiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 17694 | |
| False | 6639 | 22.5% |
| (Missing) | 5167 | 17.5% |
| Distinct | 1230 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07355550076 |
| Minimum | 0 |
|---|---|
| Maximum | 0.951 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.027 |
| Q1 | 0.0321 |
| median | 0.0413 |
| Q3 | 0.0683 |
| 95-th percentile | 0.268 |
| Maximum | 0.951 |
| Range | 0.951 |
| Interquartile range (IQR) | 0.0362 |
Descriptive statistics
| Standard deviation | 0.08315419853 |
|---|---|
| Coefficient of variation (CV) | 1.130495988 |
| Kurtosis | 12.4944506 |
| Mean | 0.07355550076 |
| Median Absolute Deviation (MAD) | 0.0116 |
| Skewness | 3.161316737 |
| Sum | 1789.826 |
| Variance | 0.006914620733 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0295 | 118 | 0.4% |
| 0.0287 | 116 | 0.4% |
| 0.0303 | 115 | 0.4% |
| 0.0299 | 114 | 0.4% |
| 0.0294 | 113 | 0.4% |
| 0.0317 | 112 | 0.4% |
| 0.029 | 111 | 0.4% |
| 0.0306 | 110 | 0.4% |
| 0.0319 | 110 | 0.4% |
| 0.0293 | 109 | 0.4% |
| Other values (1220) | 23205 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.022 | 1 | < 0.1% |
| 0.0221 | 1 | < 0.1% |
| 0.0224 | 5 | |
| 0.0225 | 3 | |
| 0.0226 | 1 | < 0.1% |
| 0.0227 | 2 | < 0.1% |
| 0.0228 | 5 | |
| 0.0229 | 3 | |
| 0.023 | 4 |
| Value | Count | Frequency (%) |
| 0.951 | 1 | |
| 0.924 | 1 | |
| 0.913 | 1 | |
| 0.894 | 1 | |
| 0.888 | 1 | |
| 0.858 | 1 | |
| 0.855 | 1 | |
| 0.847 | 1 | |
| 0.846 | 2 | |
| 0.74 | 1 |
| Distinct | 3057 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2946368962 |
| Minimum | 2.51 × 10-6 |
|---|---|
| Maximum | 0.991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 2.51 × 10-6 |
|---|---|
| 5-th percentile | 0.00265 |
| Q1 | 0.0467 |
| median | 0.195 |
| Q3 | 0.508 |
| 95-th percentile | 0.839 |
| Maximum | 0.991 |
| Range | 0.99099749 |
| Interquartile range (IQR) | 0.4613 |
Descriptive statistics
| Standard deviation | 0.2823054681 |
|---|---|
| Coefficient of variation (CV) | 0.9581470337 |
| Kurtosis | -0.7204904632 |
| Mean | 0.2946368962 |
| Median Absolute Deviation (MAD) | 0.1748 |
| Skewness | 0.7615593299 |
| Sum | 7169.399595 |
| Variance | 0.07969637731 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.117 | 50 | 0.2% |
| 0.111 | 48 | 0.2% |
| 0.113 | 47 | 0.2% |
| 0.107 | 47 | 0.2% |
| 0.101 | 47 | 0.2% |
| 0.13 | 45 | 0.2% |
| 0.114 | 45 | 0.2% |
| 0.105 | 45 | 0.2% |
| 0.104 | 44 | 0.1% |
| 0.108 | 44 | 0.1% |
| Other values (3047) | 23871 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 2.51 × 10-6 | 1 | |
| 3.28 × 10-6 | 1 | |
| 3.29 × 10-6 | 1 | |
| 5.67 × 10-6 | 1 | |
| 7.81 × 10-6 | 1 | |
| 8 × 10-6 | 1 | |
| 9.4 × 10-6 | 1 | |
| 9.44 × 10-6 | 1 | |
| 1.21 × 10-5 | 2 | |
| 1.24 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 0.991 | 1 | < 0.1% |
| 0.99 | 2 | < 0.1% |
| 0.989 | 1 | < 0.1% |
| 0.988 | 4 | |
| 0.987 | 5 | |
| 0.986 | 1 | < 0.1% |
| 0.985 | 1 | < 0.1% |
| 0.983 | 2 | < 0.1% |
| 0.982 | 2 | < 0.1% |
| 0.981 | 3 |
| Distinct | 4423 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03254034614 |
| Minimum | 0 |
|---|---|
| Maximum | 0.982 |
| Zeros | 10079 |
| Zeros (%) | 34.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4.53 × 10-6 |
| Q3 | 0.00046 |
| 95-th percentile | 0.1694 |
| Maximum | 0.982 |
| Range | 0.982 |
| Interquartile range (IQR) | 0.00046 |
Descriptive statistics
| Standard deviation | 0.1362787863 |
|---|---|
| Coefficient of variation (CV) | 4.187994366 |
| Kurtosis | 25.58618698 |
| Mean | 0.03254034614 |
| Median Absolute Deviation (MAD) | 4.53 × 10-6 |
| Skewness | 5.040325148 |
| Sum | 791.8042427 |
| Variance | 0.0185719076 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10079 | |
| 1.16 × 10-6 | 25 | 0.1% |
| 1.03 × 10-5 | 25 | 0.1% |
| 1.17 × 10-6 | 19 | 0.1% |
| 1.2 × 10-6 | 19 | 0.1% |
| 1.19 × 10-6 | 18 | 0.1% |
| 1.23 × 10-5 | 18 | 0.1% |
| 0.000104 | 18 | 0.1% |
| 1.19 × 10-5 | 18 | 0.1% |
| 1.05 × 10-5 | 18 | 0.1% |
| Other values (4413) | 14076 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0 | 10079 | |
| 1 × 10-6 | 4 | < 0.1% |
| 1.01 × 10-6 | 17 | 0.1% |
| 1.02 × 10-6 | 14 | < 0.1% |
| 1.03 × 10-6 | 15 | 0.1% |
| 1.04 × 10-6 | 12 | < 0.1% |
| 1.05 × 10-6 | 12 | < 0.1% |
| 1.06 × 10-6 | 6 | < 0.1% |
| 1.07 × 10-6 | 10 | < 0.1% |
| 1.08 × 10-6 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.982 | 2 | |
| 0.981 | 1 | < 0.1% |
| 0.978 | 1 | < 0.1% |
| 0.966 | 2 | |
| 0.965 | 2 | |
| 0.963 | 3 | |
| 0.962 | 2 | |
| 0.961 | 2 | |
| 0.96 | 1 | < 0.1% |
| 0.959 | 1 | < 0.1% |
| Distinct | 1611 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1921024152 |
| Minimum | 0.00967 |
|---|---|
| Maximum | 0.999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0.00967 |
|---|---|
| 5-th percentile | 0.0521 |
| Q1 | 0.0909 |
| median | 0.131 |
| Q3 | 0.249 |
| 95-th percentile | 0.533 |
| Maximum | 0.999 |
| Range | 0.98933 |
| Interquartile range (IQR) | 0.1581 |
Descriptive statistics
| Standard deviation | 0.1590751067 |
|---|---|
| Coefficient of variation (CV) | 0.8280744753 |
| Kurtosis | 5.183101997 |
| Mean | 0.1921024152 |
| Median Absolute Deviation (MAD) | 0.0558 |
| Skewness | 2.104279463 |
| Sum | 4674.42807 |
| Variance | 0.02530488957 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.106 | 202 | 0.7% |
| 0.111 | 200 | 0.7% |
| 0.107 | 197 | 0.7% |
| 0.108 | 189 | 0.6% |
| 0.11 | 185 | 0.6% |
| 0.105 | 183 | 0.6% |
| 0.114 | 180 | 0.6% |
| 0.109 | 179 | 0.6% |
| 0.112 | 176 | 0.6% |
| 0.104 | 175 | 0.6% |
| Other values (1601) | 22467 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0.00967 | 1 | |
| 0.013 | 1 | |
| 0.0136 | 2 | |
| 0.0145 | 1 | |
| 0.0146 | 1 | |
| 0.0166 | 1 | |
| 0.0169 | 1 | |
| 0.0184 | 1 | |
| 0.0186 | 1 | |
| 0.0189 | 1 |
| Value | Count | Frequency (%) |
| 0.999 | 1 | |
| 0.997 | 1 | |
| 0.991 | 1 | |
| 0.99 | 2 | |
| 0.989 | 2 | |
| 0.988 | 2 | |
| 0.987 | 1 | |
| 0.986 | 1 | |
| 0.984 | 2 | |
| 0.982 | 1 |
| Distinct | 1103 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6017609789 |
| Minimum | 0 |
|---|---|
| Maximum | 0.991 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.189 |
| Q1 | 0.415 |
| median | 0.622 |
| Q3 | 0.802 |
| 95-th percentile | 0.955 |
| Maximum | 0.991 |
| Range | 0.991 |
| Interquartile range (IQR) | 0.387 |
Descriptive statistics
| Standard deviation | 0.2386377227 |
|---|---|
| Coefficient of variation (CV) | 0.3965656316 |
| Kurtosis | -0.940241214 |
| Mean | 0.6017609789 |
| Median Absolute Deviation (MAD) | 0.192 |
| Skewness | -0.2711212212 |
| Sum | 14642.6499 |
| Variance | 0.05694796268 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.961 | 136 | 0.5% |
| 0.962 | 118 | 0.4% |
| 0.963 | 118 | 0.4% |
| 0.964 | 100 | 0.3% |
| 0.965 | 91 | 0.3% |
| 0.96 | 83 | 0.3% |
| 0.966 | 71 | 0.2% |
| 0.969 | 58 | 0.2% |
| 0.967 | 57 | 0.2% |
| 0.926 | 56 | 0.2% |
| Other values (1093) | 23445 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.0349 | 1 | |
| 0.0352 | 1 | |
| 0.0359 | 1 | |
| 0.0361 | 1 | |
| 0.0363 | 1 | |
| 0.0364 | 1 | |
| 0.0371 | 2 | |
| 0.0373 | 1 | |
| 0.0376 | 1 |
| Value | Count | Frequency (%) |
| 0.991 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 0.989 | 1 | < 0.1% |
| 0.988 | 1 | < 0.1% |
| 0.987 | 1 | < 0.1% |
| 0.986 | 1 | < 0.1% |
| 0.985 | 3 | |
| 0.984 | 1 | < 0.1% |
| 0.983 | 2 | |
| 0.982 | 2 |
| Distinct | 20484 |
|---|---|
| Distinct (%) | 84.2% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.2775407 |
| Minimum | 0 |
|---|---|
| Maximum | 241.009 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 230.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 79.1556 |
| Q1 | 99.063 |
| median | 118.913 |
| Q3 | 136.484 |
| 95-th percentile | 173.828 |
| Maximum | 241.009 |
| Range | 241.009 |
| Interquartile range (IQR) | 37.421 |
Descriptive statistics
| Standard deviation | 28.04656978 |
|---|---|
| Coefficient of variation (CV) | 0.2331821021 |
| Kurtosis | 0.01721647799 |
| Mean | 120.2775407 |
| Median Absolute Deviation (MAD) | 18.926 |
| Skewness | 0.5138985749 |
| Sum | 2926713.398 |
| Variance | 786.6100765 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 119.987 | 8 | < 0.1% |
| 119.991 | 7 | < 0.1% |
| 113 | 6 | < 0.1% |
| 125.008 | 6 | < 0.1% |
| 120.08 | 6 | < 0.1% |
| 119.999 | 6 | < 0.1% |
| 99.991 | 6 | < 0.1% |
| 116 | 6 | < 0.1% |
| 140.022 | 6 | < 0.1% |
| 128.002 | 6 | < 0.1% |
| Other values (20474) | 24270 | |
| (Missing) | 5167 | 17.5% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 35.716 | 1 | |
| 36.71 | 1 | |
| 37.114 | 1 | |
| 47.94 | 1 | |
| 48.718 | 1 | |
| 50.937 | 1 | |
| 51.391 | 1 | |
| 51.409 | 1 | |
| 53.919 | 1 |
| Value | Count | Frequency (%) |
| 241.009 | 1 | |
| 233.429 | 1 | |
| 216.2 | 1 | |
| 213.737 | 1 | |
| 211.261 | 1 | |
| 211.206 | 1 | |
| 210.874 | 1 | |
| 210.75 | 1 | |
| 210.186 | 1 | |
| 209.819 | 1 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5167 |
| Missing (%) | 17.5% |
| Memory size | 230.6 KiB |
| 4.0 | |
|---|---|
| 3.0 | 1564 |
| 5.0 | 186 |
| 1.0 | 92 |
| 0.0 | 2 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 72999 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 4.0 |
| 4th row | 4.0 |
| 5th row | 4.0 |
Common Values
| Value | Count | Frequency (%) |
| 4.0 | 22489 | |
| 3.0 | 1564 | 5.3% |
| 5.0 | 186 | 0.6% |
| 1.0 | 92 | 0.3% |
| 0.0 | 2 | < 0.1% |
| (Missing) | 5167 | 17.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 4.0 | 22489 | |
| 3.0 | 1564 | 6.4% |
| 5.0 | 186 | 0.8% |
| 1.0 | 92 | 0.4% |
| 0.0 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 24335 | |
| . | 24333 | |
| 4 | 22489 | |
| 3 | 1564 | 2.1% |
| 5 | 186 | 0.3% |
| 1 | 92 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48666 | |
| Other Punctuation | 24333 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 24335 | |
| 4 | 22489 | |
| 3 | 1564 | 3.2% |
| 5 | 186 | 0.4% |
| 1 | 92 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 24333 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 72999 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 24335 | |
| . | 24333 | |
| 4 | 22489 | |
| 3 | 1564 | 2.1% |
| 5 | 186 | 0.3% |
| 1 | 92 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72999 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 24335 | |
| . | 24333 | |
| 4 | 22489 | |
| 3 | 1564 | 2.1% |
| 5 | 186 | 0.3% |
| 1 | 92 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| weekid | week_position | song | performer | weeks_on_chart | peak_position | spotify_track_duration_ms | spotify_track_explicit | danceability | energy | key | loudness | mode | speechiness | acousticness | instrumentalness | liveness | valence | tempo | time_signature | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2009-12-26 | 51 | My Life Would Suck Without You | Glee Cast | 1 | 51 | 211800.0 | False | 0.471 | 0.663 | 9.0 | -6.284 | True | 0.0348 | 0.01770 | 0.000000 | 0.0801 | 0.449 | 145.078 | 4.0 |
| 1 | 2014-01-04 | 51 | I Have Nothing | Tessanne Chin | 1 | 51 | 231141.0 | False | 0.398 | 0.639 | 9.0 | -3.517 | False | 0.0338 | 0.23500 | 0.000000 | 0.0972 | 0.197 | 154.247 | 3.0 |
| 2 | 2017-07-29 | 51 | Family Feud | JAY-Z Featuring Beyonce | 1 | 51 | 251413.0 | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 2018-12-22 | 51 | I Don't Let Go | XXXTENTACION | 1 | 51 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 2019-06-01 | 51 | I Think | Tyler, The Creator | 1 | 51 | 212013.0 | True | 0.826 | 0.579 | 8.0 | -8.241 | False | 0.0801 | 0.00881 | 0.000000 | 0.1290 | 0.431 | 121.075 | 4.0 |
| 5 | 2019-09-07 | 51 | I Think He Knows | Taylor Swift | 1 | 51 | 173386.0 | False | 0.897 | 0.366 | 0.0 | -8.029 | True | 0.0569 | 0.00889 | 0.000353 | 0.0715 | 0.416 | 100.003 | 4.0 |
| 6 | 2020-05-16 | 51 | Losses | Drake | 1 | 51 | 271183.0 | True | 0.551 | 0.570 | 1.0 | -7.385 | False | 0.3510 | 0.28000 | 0.000000 | 0.4240 | 0.505 | 85.687 | 4.0 |
| 7 | 2010-10-16 | 52 | I'm A Slave 4 U | Glee Cast | 1 | 52 | 204053.0 | False | 0.909 | 0.779 | 0.0 | -4.004 | False | 0.1360 | 0.40900 | 0.000681 | 0.0398 | 0.955 | 110.022 | 4.0 |
| 8 | 2011-04-02 | 52 | Misery | Glee Cast | 1 | 52 | 188800.0 | False | 0.749 | 0.631 | 7.0 | -5.826 | True | 0.0569 | 0.18800 | 0.000000 | 0.1100 | 0.812 | 102.962 | 4.0 |
| 9 | 2011-09-17 | 52 | MegaMan | Lil Wayne | 1 | 52 | 198280.0 | True | 0.504 | 0.856 | 11.0 | -5.024 | False | 0.2860 | 0.01140 | 0.000000 | 0.2560 | 0.335 | 101.866 | 5.0 |
Last rows
| weekid | week_position | song | performer | weeks_on_chart | peak_position | spotify_track_duration_ms | spotify_track_explicit | danceability | energy | key | loudness | mode | speechiness | acousticness | instrumentalness | liveness | valence | tempo | time_signature | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29490 | 1962-07-28 | 77 | Sweet And Lovely | April Stevens & Nino Tempo | 4 | 77 | 175533.0 | False | 0.669 | 0.515 | 10.0 | -11.804 | True | 0.0396 | 0.617 | 0.0 | 0.3060 | 0.865 | 121.928 | 4.0 |
| 29491 | 1963-01-26 | 77 | Darkest Street In Town | Jimmy Clanton | 4 | 77 | 139760.0 | False | 0.502 | 0.832 | 5.0 | -7.354 | False | 0.0394 | 0.417 | 0.0 | 0.0897 | 0.975 | 147.778 | 4.0 |
| 29492 | 1966-07-23 | 77 | Ain't Gonna Cry No More | Brenda Lee | 4 | 77 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 29493 | 1977-12-03 | 77 | Still The Lovin' Is Fun | B.J. Thomas | 4 | 77 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 29494 | 1964-04-11 | 78 | Roll Over Beethoven | The Beatles | 4 | 68 | 165466.0 | False | 0.351 | 0.749 | 2.0 | -9.435 | True | 0.0628 | 0.289 | 0.0 | 0.0952 | 0.967 | 160.673 | 4.0 |
| 29495 | 1959-03-14 | 78 | Bunny Hop | The Applejacks | 4 | 70 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 29496 | 1967-03-11 | 78 | Peek-A-Boo | The New Vaudeville Band | 4 | 72 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 29497 | 1964-01-25 | 78 | Do-Wah-Diddy | The Exciters | 4 | 78 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 29498 | 1965-08-28 | 78 | Summer Wind | Wayne Newton | 4 | 78 | 157760.0 | False | 0.469 | 0.327 | 6.0 | -15.184 | True | 0.0343 | 0.432 | 0.0 | 0.2690 | 0.556 | 114.647 | 4.0 |
| 29499 | 1968-10-19 | 78 | Oh Lord, Why Lord | Los Pop Tops | 4 | 78 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
Most frequently occurring
| weekid | week_position | song | performer | weeks_on_chart | peak_position | spotify_track_duration_ms | spotify_track_explicit | danceability | energy | key | loudness | mode | speechiness | acousticness | instrumentalness | liveness | valence | tempo | time_signature | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-06-29 | 45 | When The Party's Over | Billie Eilish | 32 | 29 | 196077.0 | False | 0.367 | 0.111 | 4.0 | -14.084 | True | 0.0972 | 0.97800 | 0.000040 | 0.0897 | 0.198 | 82.642 | 4.0 | 2 |
| 1 | 2019-06-29 | 47 | Envy Me | Calboy | 27 | 31 | 120133.0 | True | 0.740 | 0.488 | 1.0 | -7.664 | False | 0.2700 | 0.23400 | 0.000000 | 0.2410 | 0.584 | 149.042 | 4.0 | 2 |
| 2 | 2019-06-29 | 70 | Miss Me More | Kelsea Ballerini | 20 | 47 | 192840.0 | False | 0.643 | 0.720 | 2.0 | -7.146 | True | 0.0527 | 0.01400 | 0.000000 | 0.0834 | 0.491 | 96.028 | 4.0 | 2 |
| 3 | 2019-06-29 | 99 | Racks In The Middle | Nipsey Hussle Featuring Roddy Ricch & Hit-Boy | 11 | 99 | 233277.0 | True | 0.671 | 0.833 | 5.0 | -5.152 | False | 0.3950 | 0.08250 | 0.000000 | 0.0726 | 0.702 | 79.351 | 4.0 | 2 |
| 4 | 2019-07-06 | 87 | Here With Me | Marshmello Featuring CHVRCHES | 16 | 31 | 156346.0 | False | 0.791 | 0.565 | 5.0 | -3.933 | False | 0.0439 | 0.06230 | 0.000000 | 0.1560 | 0.181 | 99.961 | 4.0 | 2 |
| 5 | 2019-07-06 | 88 | Love Someone | Brett Eldredge | 10 | 52 | 211720.0 | False | 0.423 | 0.813 | 9.0 | -5.011 | True | 0.0507 | 0.21800 | 0.000002 | 0.0732 | 0.421 | 173.995 | 4.0 | 2 |
| 6 | 2019-07-06 | 94 | Big Ole Freak | Megan Thee Stallion | 12 | 65 | 214850.0 | True | 0.799 | 0.699 | 2.0 | -7.694 | True | 0.2040 | 0.00867 | 0.000000 | 0.1320 | 0.627 | 142.979 | 4.0 | 2 |
| 7 | 2019-07-06 | 96 | You Stay | DJ Khaled Featuring Meek Mill, J Balvin, Lil Baby & Jeremih | 4 | 96 | 275275.0 | True | 0.479 | 0.630 | 7.0 | -5.628 | False | 0.1330 | 0.03140 | 0.000000 | 0.0730 | 0.227 | 117.988 | 5.0 | 2 |
| 8 | 2019-07-13 | 71 | Homicide | Logic Featuring Eminem | 6 | 71 | 245386.0 | True | 0.694 | 0.759 | 10.0 | -5.667 | False | 0.3980 | 0.13700 | 0.000000 | 0.1670 | 0.770 | 140.055 | 4.0 | 2 |
| 9 | 2019-07-13 | 88 | Eyes On You | Chase Rice | 20 | 38 | 182493.0 | False | 0.606 | 0.652 | 9.0 | -6.982 | True | 0.0281 | 0.32300 | 0.000000 | 0.2010 | 0.476 | 97.155 | 4.0 | 2 |